SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vweAsignaturas
AS
SELECT     idAsignatura AS ID, Descripcion, Mnemo, Tipo, AsignaturaGenerica, EsPrivada
FROM         dbo.tb_Asignaturas
GO
GRANT SELECT ON  [dbo].[vweAsignaturas] TO [CentroDeDesignaciones]
GRANT SELECT ON  [dbo].[vweAsignaturas] TO [Direcciones De Nivel]
GRANT INSERT ON  [dbo].[vweAsignaturas] TO [Direcciones De Nivel]
GRANT DELETE ON  [dbo].[vweAsignaturas] TO [Direcciones De Nivel]
GRANT UPDATE ON  [dbo].[vweAsignaturas] TO [Direcciones De Nivel]
GRANT SELECT ON  [dbo].[vweAsignaturas] TO [Juntas]
GRANT UPDATE ON  [dbo].[vweAsignaturas] TO [Juntas]
GRANT SELECT ON  [dbo].[vweAsignaturas] TO [PersonalDocente]
GRANT INSERT ON  [dbo].[vweAsignaturas] TO [PersonalDocente]
GRANT DELETE ON  [dbo].[vweAsignaturas] TO [PersonalDocente]
GRANT UPDATE ON  [dbo].[vweAsignaturas] TO [PersonalDocente]
GRANT REFERENCES ON  [dbo].[vweAsignaturas] TO [Reestructura]
GRANT SELECT ON  [dbo].[vweAsignaturas] TO [Reestructura]
GRANT INSERT ON  [dbo].[vweAsignaturas] TO [Reestructura]
GRANT DELETE ON  [dbo].[vweAsignaturas] TO [Reestructura]
GRANT UPDATE ON  [dbo].[vweAsignaturas] TO [Reestructura]
GRANT SELECT ON  [dbo].[vweAsignaturas] TO [RegistroTitulos]
GRANT INSERT ON  [dbo].[vweAsignaturas] TO [RegistroTitulos]
GRANT DELETE ON  [dbo].[vweAsignaturas] TO [RegistroTitulos]
GRANT UPDATE ON  [dbo].[vweAsignaturas] TO [RegistroTitulos]
GRANT SELECT ON  [dbo].[vweAsignaturas] TO [SoloVer]
GO
